﻿-- =============================================
-- Author:		<Author,XFL>
-- Create date: <Create Date,20111230>
-- Description:	<Description,--新建固定补助>
-- =============================================
CREATE PROCEDURE [dbo].[proc_Employee_FixedAllowance_Create]
(
	@UserName nvarchar(50),
	@EName nvarchar(50),
	@Amount decimal(18, 2),
	@Memo nvarchar(1000)
)
AS
BEGIN
	Declare @CompanyId int,@DepartmentId int
		Select @CompanyId=CompanyId,@DepartmentId=DepartmentId From Employee Where UserName=@UserName
		
		Insert Into Employee_FixedAllowance
		(
			CompanyId,
			DepartmentId,
			UserName,
			EName,
			Amount,
			Memo,
			CreateDate
		)
		Values
		(
			@CompanyId,
			@DepartmentId,
			@UserName,
			@EName,
			@Amount,
			@Memo,
			GetDate()
		)
END
